package alipay.openplatform.edu.campus.jiuye.dao.mappers.system;

import alipay.openplatform.edu.campus.jiuye.model.po.SchoolInfoPO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface SchoolInfoMapper {

    /**
     * 分页获取城市信息 - ZONG
     *
     * @param schoolId 学校编号
     * @return
     */
    int deleteByPrimaryKey(@Param("schoolId") String schoolId);

    int insert(SchoolInfoPO record);

    int insertSelective(SchoolInfoPO record);

    SchoolInfoPO selectByPrimaryKey(Integer schoolId);

    int updateByPrimaryKeySelective(SchoolInfoPO record);

    int updateByPrimaryKey(SchoolInfoPO record);


    /**
     * 分页获取城市信息 - ZONG
     *
     * @param schoolName 学校名称
     * @param pageStart  当前页的编号
     * @param pageRows   每页的行数
     * @return
     */
    List<SchoolInfoPO> getSchoolPage(@Param("schoolName") String schoolName, @Param("pageStart") int pageStart, @Param("pageRows") int pageRows);


    /**
     * 获取城市信息的条数 - ZONG
     *
     * @param schoolName 学校名称
     * @return
     */
    Integer getSchoolInfoCount(@Param("schoolName") String schoolName);

    List<SchoolInfoPO> getUnion();

    Long getCityIdBySchoolId(@Param("schoolId") String schoolId);
}